package com.czp.ssm.bean;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class PlaneOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PlaneOrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("ORDER_ID =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("ORDER_ID <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("ORDER_ID >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_ID >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("ORDER_ID <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("ORDER_ID <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("ORDER_ID like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("ORDER_ID not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("ORDER_ID in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("ORDER_ID not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("ORDER_ID between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("ORDER_ID not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("ORDER_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("ORDER_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(String value) {
            addCriterion("ORDER_STATUS =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(String value) {
            addCriterion("ORDER_STATUS <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(String value) {
            addCriterion("ORDER_STATUS >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_STATUS >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(String value) {
            addCriterion("ORDER_STATUS <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(String value) {
            addCriterion("ORDER_STATUS <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLike(String value) {
            addCriterion("ORDER_STATUS like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotLike(String value) {
            addCriterion("ORDER_STATUS not like", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<String> values) {
            addCriterion("ORDER_STATUS in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<String> values) {
            addCriterion("ORDER_STATUS not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(String value1, String value2) {
            addCriterion("ORDER_STATUS between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(String value1, String value2) {
            addCriterion("ORDER_STATUS not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIsNull() {
            addCriterion("ORDER_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIsNotNull() {
            addCriterion("ORDER_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPriceEqualTo(BigDecimal value) {
            addCriterion("ORDER_PRICE =", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotEqualTo(BigDecimal value) {
            addCriterion("ORDER_PRICE <>", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceGreaterThan(BigDecimal value) {
            addCriterion("ORDER_PRICE >", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDER_PRICE >=", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceLessThan(BigDecimal value) {
            addCriterion("ORDER_PRICE <", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDER_PRICE <=", value, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceIn(List<BigDecimal> values) {
            addCriterion("ORDER_PRICE in", values, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotIn(List<BigDecimal> values) {
            addCriterion("ORDER_PRICE not in", values, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDER_PRICE between", value1, value2, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andOrderPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDER_PRICE not between", value1, value2, "orderPrice");
            return (Criteria) this;
        }

        public Criteria andPayTypeIsNull() {
            addCriterion("PAY_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andPayTypeIsNotNull() {
            addCriterion("PAY_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andPayTypeEqualTo(String value) {
            addCriterion("PAY_TYPE =", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeNotEqualTo(String value) {
            addCriterion("PAY_TYPE <>", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeGreaterThan(String value) {
            addCriterion("PAY_TYPE >", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_TYPE >=", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeLessThan(String value) {
            addCriterion("PAY_TYPE <", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeLessThanOrEqualTo(String value) {
            addCriterion("PAY_TYPE <=", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeLike(String value) {
            addCriterion("PAY_TYPE like", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeNotLike(String value) {
            addCriterion("PAY_TYPE not like", value, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeIn(List<String> values) {
            addCriterion("PAY_TYPE in", values, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeNotIn(List<String> values) {
            addCriterion("PAY_TYPE not in", values, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeBetween(String value1, String value2) {
            addCriterion("PAY_TYPE between", value1, value2, "payType");
            return (Criteria) this;
        }

        public Criteria andPayTypeNotBetween(String value1, String value2) {
            addCriterion("PAY_TYPE not between", value1, value2, "payType");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNull() {
            addCriterion("START_DATE is null");
            return (Criteria) this;
        }

        public Criteria andStartDateIsNotNull() {
            addCriterion("START_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andStartDateEqualTo(String value) {
            addCriterion("START_DATE =", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotEqualTo(String value) {
            addCriterion("START_DATE <>", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThan(String value) {
            addCriterion("START_DATE >", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateGreaterThanOrEqualTo(String value) {
            addCriterion("START_DATE >=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThan(String value) {
            addCriterion("START_DATE <", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLessThanOrEqualTo(String value) {
            addCriterion("START_DATE <=", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateLike(String value) {
            addCriterion("START_DATE like", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotLike(String value) {
            addCriterion("START_DATE not like", value, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateIn(List<String> values) {
            addCriterion("START_DATE in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotIn(List<String> values) {
            addCriterion("START_DATE not in", values, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateBetween(String value1, String value2) {
            addCriterion("START_DATE between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andStartDateNotBetween(String value1, String value2) {
            addCriterion("START_DATE not between", value1, value2, "startDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNull() {
            addCriterion("END_DATE is null");
            return (Criteria) this;
        }

        public Criteria andEndDateIsNotNull() {
            addCriterion("END_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andEndDateEqualTo(String value) {
            addCriterion("END_DATE =", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotEqualTo(String value) {
            addCriterion("END_DATE <>", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThan(String value) {
            addCriterion("END_DATE >", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateGreaterThanOrEqualTo(String value) {
            addCriterion("END_DATE >=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThan(String value) {
            addCriterion("END_DATE <", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLessThanOrEqualTo(String value) {
            addCriterion("END_DATE <=", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateLike(String value) {
            addCriterion("END_DATE like", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotLike(String value) {
            addCriterion("END_DATE not like", value, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateIn(List<String> values) {
            addCriterion("END_DATE in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotIn(List<String> values) {
            addCriterion("END_DATE not in", values, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateBetween(String value1, String value2) {
            addCriterion("END_DATE between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andEndDateNotBetween(String value1, String value2) {
            addCriterion("END_DATE not between", value1, value2, "endDate");
            return (Criteria) this;
        }

        public Criteria andStartCityIsNull() {
            addCriterion("START_CITY is null");
            return (Criteria) this;
        }

        public Criteria andStartCityIsNotNull() {
            addCriterion("START_CITY is not null");
            return (Criteria) this;
        }

        public Criteria andStartCityEqualTo(String value) {
            addCriterion("START_CITY =", value, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityNotEqualTo(String value) {
            addCriterion("START_CITY <>", value, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityGreaterThan(String value) {
            addCriterion("START_CITY >", value, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityGreaterThanOrEqualTo(String value) {
            addCriterion("START_CITY >=", value, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityLessThan(String value) {
            addCriterion("START_CITY <", value, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityLessThanOrEqualTo(String value) {
            addCriterion("START_CITY <=", value, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityLike(String value) {
            addCriterion("START_CITY like", value, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityNotLike(String value) {
            addCriterion("START_CITY not like", value, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityIn(List<String> values) {
            addCriterion("START_CITY in", values, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityNotIn(List<String> values) {
            addCriterion("START_CITY not in", values, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityBetween(String value1, String value2) {
            addCriterion("START_CITY between", value1, value2, "startCity");
            return (Criteria) this;
        }

        public Criteria andStartCityNotBetween(String value1, String value2) {
            addCriterion("START_CITY not between", value1, value2, "startCity");
            return (Criteria) this;
        }

        public Criteria andEndCityIsNull() {
            addCriterion("END_CITY is null");
            return (Criteria) this;
        }

        public Criteria andEndCityIsNotNull() {
            addCriterion("END_CITY is not null");
            return (Criteria) this;
        }

        public Criteria andEndCityEqualTo(String value) {
            addCriterion("END_CITY =", value, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityNotEqualTo(String value) {
            addCriterion("END_CITY <>", value, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityGreaterThan(String value) {
            addCriterion("END_CITY >", value, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityGreaterThanOrEqualTo(String value) {
            addCriterion("END_CITY >=", value, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityLessThan(String value) {
            addCriterion("END_CITY <", value, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityLessThanOrEqualTo(String value) {
            addCriterion("END_CITY <=", value, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityLike(String value) {
            addCriterion("END_CITY like", value, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityNotLike(String value) {
            addCriterion("END_CITY not like", value, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityIn(List<String> values) {
            addCriterion("END_CITY in", values, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityNotIn(List<String> values) {
            addCriterion("END_CITY not in", values, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityBetween(String value1, String value2) {
            addCriterion("END_CITY between", value1, value2, "endCity");
            return (Criteria) this;
        }

        public Criteria andEndCityNotBetween(String value1, String value2) {
            addCriterion("END_CITY not between", value1, value2, "endCity");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportIsNull() {
            addCriterion("START_PLANE_AIRPORT is null");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportIsNotNull() {
            addCriterion("START_PLANE_AIRPORT is not null");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportEqualTo(String value) {
            addCriterion("START_PLANE_AIRPORT =", value, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportNotEqualTo(String value) {
            addCriterion("START_PLANE_AIRPORT <>", value, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportGreaterThan(String value) {
            addCriterion("START_PLANE_AIRPORT >", value, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportGreaterThanOrEqualTo(String value) {
            addCriterion("START_PLANE_AIRPORT >=", value, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportLessThan(String value) {
            addCriterion("START_PLANE_AIRPORT <", value, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportLessThanOrEqualTo(String value) {
            addCriterion("START_PLANE_AIRPORT <=", value, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportLike(String value) {
            addCriterion("START_PLANE_AIRPORT like", value, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportNotLike(String value) {
            addCriterion("START_PLANE_AIRPORT not like", value, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportIn(List<String> values) {
            addCriterion("START_PLANE_AIRPORT in", values, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportNotIn(List<String> values) {
            addCriterion("START_PLANE_AIRPORT not in", values, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportBetween(String value1, String value2) {
            addCriterion("START_PLANE_AIRPORT between", value1, value2, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andStartPlaneAirportNotBetween(String value1, String value2) {
            addCriterion("START_PLANE_AIRPORT not between", value1, value2, "startPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportIsNull() {
            addCriterion("END_PLANE_AIRPORT is null");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportIsNotNull() {
            addCriterion("END_PLANE_AIRPORT is not null");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportEqualTo(String value) {
            addCriterion("END_PLANE_AIRPORT =", value, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportNotEqualTo(String value) {
            addCriterion("END_PLANE_AIRPORT <>", value, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportGreaterThan(String value) {
            addCriterion("END_PLANE_AIRPORT >", value, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportGreaterThanOrEqualTo(String value) {
            addCriterion("END_PLANE_AIRPORT >=", value, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportLessThan(String value) {
            addCriterion("END_PLANE_AIRPORT <", value, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportLessThanOrEqualTo(String value) {
            addCriterion("END_PLANE_AIRPORT <=", value, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportLike(String value) {
            addCriterion("END_PLANE_AIRPORT like", value, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportNotLike(String value) {
            addCriterion("END_PLANE_AIRPORT not like", value, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportIn(List<String> values) {
            addCriterion("END_PLANE_AIRPORT in", values, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportNotIn(List<String> values) {
            addCriterion("END_PLANE_AIRPORT not in", values, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportBetween(String value1, String value2) {
            addCriterion("END_PLANE_AIRPORT between", value1, value2, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andEndPlaneAirportNotBetween(String value1, String value2) {
            addCriterion("END_PLANE_AIRPORT not between", value1, value2, "endPlaneAirport");
            return (Criteria) this;
        }

        public Criteria andAircraftNameIsNull() {
            addCriterion("AIRCRAFT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andAircraftNameIsNotNull() {
            addCriterion("AIRCRAFT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andAircraftNameEqualTo(String value) {
            addCriterion("AIRCRAFT_NAME =", value, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameNotEqualTo(String value) {
            addCriterion("AIRCRAFT_NAME <>", value, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameGreaterThan(String value) {
            addCriterion("AIRCRAFT_NAME >", value, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameGreaterThanOrEqualTo(String value) {
            addCriterion("AIRCRAFT_NAME >=", value, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameLessThan(String value) {
            addCriterion("AIRCRAFT_NAME <", value, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameLessThanOrEqualTo(String value) {
            addCriterion("AIRCRAFT_NAME <=", value, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameLike(String value) {
            addCriterion("AIRCRAFT_NAME like", value, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameNotLike(String value) {
            addCriterion("AIRCRAFT_NAME not like", value, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameIn(List<String> values) {
            addCriterion("AIRCRAFT_NAME in", values, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameNotIn(List<String> values) {
            addCriterion("AIRCRAFT_NAME not in", values, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameBetween(String value1, String value2) {
            addCriterion("AIRCRAFT_NAME between", value1, value2, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andAircraftNameNotBetween(String value1, String value2) {
            addCriterion("AIRCRAFT_NAME not between", value1, value2, "aircraftName");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("USER_ID is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("USER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("USER_ID =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("USER_ID <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("USER_ID >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("USER_ID >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("USER_ID <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("USER_ID <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("USER_ID like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("USER_ID not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("USER_ID in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("USER_ID not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("USER_ID between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("USER_ID not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNull() {
            addCriterion("COMPANY_ID is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNotNull() {
            addCriterion("COMPANY_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdEqualTo(String value) {
            addCriterion("COMPANY_ID =", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotEqualTo(String value) {
            addCriterion("COMPANY_ID <>", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThan(String value) {
            addCriterion("COMPANY_ID >", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThanOrEqualTo(String value) {
            addCriterion("COMPANY_ID >=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThan(String value) {
            addCriterion("COMPANY_ID <", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThanOrEqualTo(String value) {
            addCriterion("COMPANY_ID <=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLike(String value) {
            addCriterion("COMPANY_ID like", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotLike(String value) {
            addCriterion("COMPANY_ID not like", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIn(List<String> values) {
            addCriterion("COMPANY_ID in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotIn(List<String> values) {
            addCriterion("COMPANY_ID not in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdBetween(String value1, String value2) {
            addCriterion("COMPANY_ID between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotBetween(String value1, String value2) {
            addCriterion("COMPANY_ID not between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdIsNull() {
            addCriterion("OPERA_PERSON_ID is null");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdIsNotNull() {
            addCriterion("OPERA_PERSON_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdEqualTo(String value) {
            addCriterion("OPERA_PERSON_ID =", value, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdNotEqualTo(String value) {
            addCriterion("OPERA_PERSON_ID <>", value, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdGreaterThan(String value) {
            addCriterion("OPERA_PERSON_ID >", value, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdGreaterThanOrEqualTo(String value) {
            addCriterion("OPERA_PERSON_ID >=", value, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdLessThan(String value) {
            addCriterion("OPERA_PERSON_ID <", value, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdLessThanOrEqualTo(String value) {
            addCriterion("OPERA_PERSON_ID <=", value, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdLike(String value) {
            addCriterion("OPERA_PERSON_ID like", value, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdNotLike(String value) {
            addCriterion("OPERA_PERSON_ID not like", value, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdIn(List<String> values) {
            addCriterion("OPERA_PERSON_ID in", values, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdNotIn(List<String> values) {
            addCriterion("OPERA_PERSON_ID not in", values, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdBetween(String value1, String value2) {
            addCriterion("OPERA_PERSON_ID between", value1, value2, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaPersonIdNotBetween(String value1, String value2) {
            addCriterion("OPERA_PERSON_ID not between", value1, value2, "operaPersonId");
            return (Criteria) this;
        }

        public Criteria andOperaDateIsNull() {
            addCriterion("OPERA_DATE is null");
            return (Criteria) this;
        }

        public Criteria andOperaDateIsNotNull() {
            addCriterion("OPERA_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andOperaDateEqualTo(Date value) {
            addCriterionForJDBCDate("OPERA_DATE =", value, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("OPERA_DATE <>", value, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateGreaterThan(Date value) {
            addCriterionForJDBCDate("OPERA_DATE >", value, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("OPERA_DATE >=", value, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateLessThan(Date value) {
            addCriterionForJDBCDate("OPERA_DATE <", value, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("OPERA_DATE <=", value, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateIn(List<Date> values) {
            addCriterionForJDBCDate("OPERA_DATE in", values, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("OPERA_DATE not in", values, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("OPERA_DATE between", value1, value2, "operaDate");
            return (Criteria) this;
        }

        public Criteria andOperaDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("OPERA_DATE not between", value1, value2, "operaDate");
            return (Criteria) this;
        }

        public Criteria andIsquitIsNull() {
            addCriterion("ISQUIT is null");
            return (Criteria) this;
        }

        public Criteria andIsquitIsNotNull() {
            addCriterion("ISQUIT is not null");
            return (Criteria) this;
        }

        public Criteria andIsquitEqualTo(String value) {
            addCriterion("ISQUIT =", value, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitNotEqualTo(String value) {
            addCriterion("ISQUIT <>", value, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitGreaterThan(String value) {
            addCriterion("ISQUIT >", value, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitGreaterThanOrEqualTo(String value) {
            addCriterion("ISQUIT >=", value, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitLessThan(String value) {
            addCriterion("ISQUIT <", value, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitLessThanOrEqualTo(String value) {
            addCriterion("ISQUIT <=", value, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitLike(String value) {
            addCriterion("ISQUIT like", value, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitNotLike(String value) {
            addCriterion("ISQUIT not like", value, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitIn(List<String> values) {
            addCriterion("ISQUIT in", values, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitNotIn(List<String> values) {
            addCriterion("ISQUIT not in", values, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitBetween(String value1, String value2) {
            addCriterion("ISQUIT between", value1, value2, "isquit");
            return (Criteria) this;
        }

        public Criteria andIsquitNotBetween(String value1, String value2) {
            addCriterion("ISQUIT not between", value1, value2, "isquit");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateIsNull() {
            addCriterion("CREATE_ORDER_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateIsNotNull() {
            addCriterion("CREATE_ORDER_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE =", value, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateNotEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE <>", value, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateGreaterThan(Date value) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE >", value, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE >=", value, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateLessThan(Date value) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE <", value, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE <=", value, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateIn(List<Date> values) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE in", values, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateNotIn(List<Date> values) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE not in", values, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE between", value1, value2, "createOrderDate");
            return (Criteria) this;
        }

        public Criteria andCreateOrderDateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CREATE_ORDER_DATE not between", value1, value2, "createOrderDate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}